package DBLayer;

import Model.Customer;
import java.util.ArrayList;

/**
 *
 * @author Administrator
 */
public interface DbInterfaceCustomer {
    //get all customers
    public ArrayList<Customer> getAllCustomers(String wClause);
    //find customer by unique value
    public Customer getByName(String name);
    public Customer getCustomerById(String id);
    public Customer getCustomerByPhone(String phone);
    public Customer getCustomerByEmail(String email);
    //insert new Customer
    public int insertCustomer(Customer cust);
    //update informations for one Customer
    public int updateCustomer(Customer cust);
    //delete Customer by Id
    public int deleteCustomer(String phone);

}
